<html><body>
<?
header("Content-Type: text/html; charset=utf-8");
$sessionID = $_GET['sessionID'];
$lat = $_GET['lat'];
$lon = $_GET['lon'];
$chapter = $_GET['chapter'];
$city = $_GET['city'];
$street = $_GET['street'];
$pub = $_GET['pub'];
$cafe = $_GET['cafe'];
$bakery = $_GET['bakery'];
$train = $_GET['train'];
$weather = $_GET['weather'];
$page = $_GET['page'];
$area = $_GET['area'];



$username="eu_wilhelm";
$password="n3DN67xcDwPyba4S";
$database="eu_wilhelm";


mysql_connect("gis-db.uni-muenster.de",$username,$password) or die("Connection failed: ". mysql_error());

@mysql_select_db($database) or die( "Unable to select the database: ". mysql_error());


$query = "INSERT INTO storyLogger (sessionID, lat, lon, chapter, city, street, pub, cafe, bakery, train, area, weather, page) VALUES('$sessionID', '$lat', '$lon', '$chapter', '$city', '$street', '$pub', '$cafe', '$bakery', '$train', '$area', '$weather', '$page');";


mysql_query($query) or die ("Query Error: " .mysql_error());
echo "Data inserted";

mysql_close();
 
?>
</body></html>